USE [BaseNet]
GO
/****** Object:  Table [dbo].[System_AuditLog]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_AuditLog](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[Method] [nvarchar](500) NULL,
	[RequestUrl] [nvarchar](500) NULL,
	[RefererUrl] [nvarchar](500) NULL,
	[Params] [text] NULL,
	[IPv4] [nvarchar](500) NULL,
	[IsRequestSucceed] [bit] NULL,
	[ReturnResult] [text] NULL,
 CONSTRAINT [PK_System_AuditLog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_DictField]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_DictField](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[FieldCode] [varchar](50) NULL,
	[FieldName] [nvarchar](50) NULL,
	[Explain] [nvarchar](50) NULL,
	[IsActive] [bit] NULL,
 CONSTRAINT [PK_System_DicType] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_DictItem]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_DictItem](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[DictFieldId] [varchar](50) NULL,
	[DictValue] [nvarchar](50) NULL,
	[Sort] [int] NULL,
	[IsActive] [bit] NULL,
 CONSTRAINT [PK_System_DicInfo] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_Role]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_Role](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[Name] [nvarchar](50) NULL,
	[IsActive] [bit] NULL,
	[Sort] [int] NULL,
 CONSTRAINT [PK_System_Role] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_RoleMenu]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_RoleMenu](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[RoleId] [varchar](50) NULL,
	[MenuId] [varchar](50) NULL,
 CONSTRAINT [PK_System_RoleMenu] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_RoleSecurity]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_RoleSecurity](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[RoleId] [varchar](50) NULL,
	[Security] [varchar](50) NULL,
 CONSTRAINT [PK_System_RoleSecurity] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_User]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_User](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[Account] [varchar](50) NULL,
	[Password] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[LastLoginTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_System_User] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[System_UserRole]    Script Date: 2021/12/16 14:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[System_UserRole](
	[Id] [varchar](50) NOT NULL,
	[CreationTime] [datetimeoffset](7) NULL,
	[CreatorUserId] [varchar](50) NULL,
	[CreatorUserName] [nvarchar](50) NULL,
	[LastModificationTime] [datetimeoffset](7) NULL,
	[LastModifierUserId] [varchar](50) NULL,
	[LastModifierUserName] [nvarchar](50) NULL,
	[DeletionTime] [datetimeoffset](7) NULL,
	[DeleterUserId] [varchar](50) NULL,
	[DeleterUserName] [nvarchar](50) NULL,
	[IsDeleted] [bit] NULL,
	[UserId] [varchar](50) NULL,
	[RoleId] [varchar](50) NULL,
 CONSTRAINT [PK_System_UserRole] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[System_DictField] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [FieldCode], [FieldName], [Explain], [IsActive]) VALUES (N'452698f0349d49c7a11b34ce6658b66a', CAST(N'2021-11-25T10:25:22.9395494+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'002', N'CategoryCode', N'商品类别', 1)
GO
INSERT [dbo].[System_DictField] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [FieldCode], [FieldName], [Explain], [IsActive]) VALUES (N'4f206fbd3fc24edbab11d966a451e4f1', CAST(N'2021-11-25T10:25:03.9046543+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'001', N'BrandCode', N'商品品牌', 1)
GO
INSERT [dbo].[System_DictField] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [FieldCode], [FieldName], [Explain], [IsActive]) VALUES (N'be9b08f825bd465ca0653e636e94b931', CAST(N'2021-11-25T10:25:43.5884035+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'004', N'TagCode', N'商品标签', 1)
GO
INSERT [dbo].[System_DictField] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [FieldCode], [FieldName], [Explain], [IsActive]) VALUES (N'c294e29c49ce4b69b05b42bc27d4729e', CAST(N'2021-11-25T10:25:53.1129544+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'005', N'SeasonCode', N'商品季节', 1)
GO
INSERT [dbo].[System_DictField] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [FieldCode], [FieldName], [Explain], [IsActive]) VALUES (N'ffd6c28f3b404a58b060b4acbe79a45a', CAST(N'2021-11-25T10:25:34.1704276+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'003', N'GroupCode', N'商品分组', 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'04d006efe1284f78921737ebfdec7085', CAST(N'2021-11-25T10:30:18.3000452+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'连衣裙', 22, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'07a9e994c2a54896b3f278dfbeb4c796', CAST(N'2021-11-25T10:29:55.5227217+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'休闲裤', 19, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'0ca6131a8bd141b59de42d7b407b1693', CAST(N'2021-11-25T10:28:04.8924894+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'风衣', 7, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'10eb1bcad5944b17bba837f97319aa5d', CAST(N'2021-11-25T10:29:05.0314074+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'毛衫', 14, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'1387911d4244400ca42784c1a73480ea', CAST(N'2021-11-25T10:29:44.1082460+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'小衫', 18, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'191c4b91b1dd409f95309184681dcb87', CAST(N'2021-11-25T10:29:29.1825169+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'T恤', 16, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'29784e5b5776422aaf21e4c54c47d376', CAST(N'2021-11-25T10:27:29.1871871+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'夹克', 3, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'2ea35c57aaf140d88843f47e5f069dac', CAST(N'2021-11-25T10:26:33.5372026+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'4f206fbd3fc24edbab11d966a451e4f1', N'测试品牌', 1, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'2f61183f28434a0ba0e70f135dd056c2', CAST(N'2021-11-25T10:27:20.7052575+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'马甲', 2, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'3804e1e1c4634ec19a55c269c532b57a', CAST(N'2021-11-25T10:29:17.0185813+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'背心/吊带', 15, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'382fe69979e64d0fbbe7c8d25a2b891c', CAST(N'2021-11-25T15:47:50.9397069+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'c294e29c49ce4b69b05b42bc27d4729e', N'春', 1, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'38913e594f3146cb86b2d1a3b9925354', CAST(N'2021-11-25T10:30:48.7842982+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', CAST(N'2021-11-25T10:30:55.6026882+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'打底衫', 26, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'3f66f5f97356471b8474657cc6cd7ad6', CAST(N'2021-11-25T15:47:57.0809753+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'c294e29c49ce4b69b05b42bc27d4729e', N'夏', 2, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'40f8248212a74420b873737ac039976a', CAST(N'2021-11-25T10:28:49.3733673+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'衬衫', 13, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'43ea31a3cc5e4fac92debcda33297e17', CAST(N'2021-11-25T10:29:36.8616823+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'针织衫', 17, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'44b08eab59ac478b905f4928a2faadf1', CAST(N'2021-11-25T10:28:35.1914247+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'皮草', 11, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'4a1d7fd71d5f4f2c89e14d4bfa9b9635', CAST(N'2021-11-25T10:30:32.7914996+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'套装', 24, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'825866cb451f4a11a895e660fe753a57', CAST(N'2021-11-25T10:30:04.7373469+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'半身裙', 20, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'839063501a684290909323dd93d381b7', CAST(N'2021-11-25T10:28:28.8661066+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'皮衣', 10, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'876ac863b54b415d86357516cf4c276d', CAST(N'2021-11-25T10:27:47.4114493+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'西装', 5, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'8795e12c79d0431b80d66d5413cf0971', CAST(N'2021-11-25T10:27:14.6118028+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'外套', 1, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'957b692a6d7247c39e596bc6e6d75bcb', CAST(N'2021-11-25T10:27:39.2375368+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'棉衣', 4, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'9deb0d4d82fd419e882f67225a8e2a50', CAST(N'2021-11-25T10:28:21.2171657+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'卫衣', 9, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'a13227bafdc14f71962001b8f3295995', CAST(N'2021-11-25T15:48:28.8851026+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'c294e29c49ce4b69b05b42bc27d4729e', N'冬', 4, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'a44ca3208f4a4885b03c6da0fb3f66e0', CAST(N'2021-11-25T10:30:26.3026937+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'连体裤', 23, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'ac791f76fc3d4ec4aaf009cf9c9690ea', CAST(N'2021-11-25T10:30:39.6837630+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'饰品', 25, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'c68508e032e44bfd8b8d3e46fb4c81eb', CAST(N'2021-11-25T10:28:13.6389559+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'大衣', 8, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'e9f7096a462b490b81440eae4b01919d', CAST(N'2021-11-25T10:27:56.5854416+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'羽绒服', 6, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'eb6ab4b7f1bb40199d1dcc0d9a1cebc1', CAST(N'2021-11-30T16:53:58.8383812+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'ffd6c28f3b404a58b060b4acbe79a45a', N'普通分组', 1, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'ee086b12640648cbae74654034ada25f', CAST(N'2021-11-25T10:28:41.2763120+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'围巾', 12, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'f0a0fe8afb8041108d4cf3df83472f8f', CAST(N'2021-11-25T10:30:11.0729060+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'452698f0349d49c7a11b34ce6658b66a', N'牛仔裤', 21, 1)
GO
INSERT [dbo].[System_DictItem] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [DictFieldId], [DictValue], [Sort], [IsActive]) VALUES (N'febcbca3b46b4d69a65b9946d2081da1', CAST(N'2021-11-25T15:48:19.6703639+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'c294e29c49ce4b69b05b42bc27d4729e', N'秋', 3, 1)
GO
INSERT [dbo].[System_Role] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [Name], [IsActive], [Sort]) VALUES (N'491c42bfd622448e8ecc182c87fdbe96', CAST(N'2021-11-19T12:09:09.2354016+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'管理员', 1, 1)
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'078f1906147e4203a924dc37e594c3ce', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'4b50250c9ce7cce422b85ffe8b0b3f76')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'083fec09a54b4d47b5e1cd49cdfbfba4', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'd629c735d164ac03c6a92bbb0133d972')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'0dd581e67c364612bd91411b48a951e9', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'4b50250c9ce7cce422b85ffe8b0b3f76')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'1a8e9ceda886445da59c908b0c658161', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'd90388678869dd197b64af6b6dd7f29c')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'2db02c2211a9484d92288d6c449be4c2', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'd629c735d164ac03c6a92bbb0133d972')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'32ffda4b3f9148ceac4c61d26a0e8ad8', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'7fed1b43013a749a84584a9ee6b955d7')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'4bb083e409c84773b6824b9372eeac6c', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'66e3f7946e660ac71fce88aca52479e9')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'5d7a0c5706d34ad280309db64f0c3bcf', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'7fed1b43013a749a84584a9ee6b955d7')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'60bd5c08247a45d1a41373880bd7a709', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'77ec4e06891d52dde01566979b803bc4')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'67f9c041c59d4d4bbd57ca8e6b5bc35a', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'64bbbea6d798258790b8b28bcd16680a')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'686809bf591445e09d661940f28e2629', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'4b50250c9ce7cce422b85ffe8b0b3f76')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'733587749045424bb512b285df32ecf9', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'7fed1b43013a749a84584a9ee6b955d7')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'7aeeedf971c1422facc27e30ab2ede02', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'a15d5f6eca62d47ec1fd694dca4d60bc')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'8100c325642b48848e8da7a18731260e', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'a9a1e4faecdee5e96c605caf2dd1c542')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'831286a8fd3a4335be4308909fd3f851', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'88b3a6fb10c4808efcfdb8731635ec6b')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'878b12b6c19043c1b02e5329460ae4bf', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'a9a1e4faecdee5e96c605caf2dd1c542')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'928c2d10e5e74ccb84f047445aa926a8', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'725fa6a8fe3d4d01b1af2e7dcd764226')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'a494a89cb14f49b6b575620f425b8f20', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'a9a1e4faecdee5e96c605caf2dd1c542')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'a7cb52e8e5f54e6cac4dadf0756becd8', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'79d5b91a66cdb3fd42b94337aab47168')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'ab97099f98da4861945071222bec1e24', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'0a6f75990a9d5f018e03e50a7ba058e7')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'd080f3c088b9409e87440d6bb34fa3d9', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'6852d3c6a343ba0bdb0af87d96cf3919')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'd25f5cafee69403181306a77297ff08f', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'7120ff90d3e063fbb7aec6ae1a56fdeb')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'd5d57d043a4d45d49d6fd3a223ada071', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'ae65ad780d271f4cc07ab0b6e248f22e')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'dc1ae246cf204adbab85ea565301fa2d', CAST(N'2021-11-19T12:10:54.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'88b3a6fb10c4808efcfdb8731635ec6b')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'e48453baf38747e5b31dfc9c8fc2ef52', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'6852d3c6a343ba0bdb0af87d96cf3919')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'e84f0bc7d48c4c088455962df579f432', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'd629c735d164ac03c6a92bbb0133d972')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'ea6f72173ef745f89da5e102f2e02da3', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'6852d3c6a343ba0bdb0af87d96cf3919')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'fca917691d5b4a1c9c91f2e352798c54', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'88b3a6fb10c4808efcfdb8731635ec6b')
GO
INSERT [dbo].[System_RoleMenu] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [MenuId]) VALUES (N'ff5ed7346aaa4d42811845da4c81e847', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'897f147f9dc08a13cbe7dfa2aa2c1f34')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'36bd59c8a1514203b9eec93b76ba0316', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:03.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'system.role')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'662ddbb11dfb405583ed31d1050d8c66', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:03.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'system.user')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'7f2a3e5d46724e5eb296d3e12877fbed', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'system.auditlog')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'9fded8222c994f2897bdede06b7f5ff7', CAST(N'2021-11-19T14:22:35.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, CAST(N'2021-11-24T17:25:03.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', 1, N'491c42bfd622448e8ecc182c87fdbe96', N'system.auditlog')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'a092d42173e04038b2d7125f2e9120b9', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'system.user')
GO
INSERT [dbo].[System_RoleSecurity] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [RoleId], [Security]) VALUES (N'e44e4a4522b24f629909f6ccbcec47de', CAST(N'2021-11-24T17:25:02.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'491c42bfd622448e8ecc182c87fdbe96', N'system.role')
GO
INSERT [dbo].[System_User] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [Account], [Password], [IsActive], [LastLoginTime]) VALUES (N'c6c000f4a77d5f2e0901a50b0d47d0f4', CAST(N'2021-11-19T11:57:00.0000000+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', CAST(N'2021-12-10T17:58:40.5270943+08:00' AS DateTimeOffset), NULL, NULL, NULL, NULL, NULL, 0, N'admin', N'0192023a7bbd73250516f069df18b500', 1, CAST(N'2021-12-10T17:58:40.5270885+08:00' AS DateTimeOffset))
GO
INSERT [dbo].[System_UserRole] ([Id], [CreationTime], [CreatorUserId], [CreatorUserName], [LastModificationTime], [LastModifierUserId], [LastModifierUserName], [DeletionTime], [DeleterUserId], [DeleterUserName], [IsDeleted], [UserId], [RoleId]) VALUES (N'd5204af7fab4403eab7893e04e4d6084', CAST(N'2021-11-19T12:12:22.1094114+08:00' AS DateTimeOffset), N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'admin', NULL, NULL, NULL, NULL, NULL, NULL, 0, N'c6c000f4a77d5f2e0901a50b0d47d0f4', N'491c42bfd622448e8ecc182c87fdbe96')
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'方法' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'Method'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'RequestUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'RefererUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求参数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'Params'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'访问人ip地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'IPv4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否请求成功' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'IsRequestSucceed'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返回的结果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_AuditLog', @level2type=N'COLUMN',@level2name=N'ReturnResult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统数据字典字段id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'FieldCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'FieldName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'Explain'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictField', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统数据字典项id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典类型id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'DictFieldId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'DictValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'Sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_DictItem', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_Role', @level2type=N'COLUMN',@level2name=N'Sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色菜单id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'RoleId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleMenu', @level2type=N'COLUMN',@level2name=N'MenuId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色权限id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'RoleId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_RoleSecurity', @level2type=N'COLUMN',@level2name=N'Security'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'Account'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'Password'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后登录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_User', @level2type=N'COLUMN',@level2name=N'LastLoginTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'CreationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'CreatorUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'CreatorUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'LastModificationTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'LastModifierUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近更新人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'LastModifierUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'DeletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'DeleterUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'DeleterUserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'UserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'System_UserRole', @level2type=N'COLUMN',@level2name=N'RoleId'
GO
